To recap where Part 1 of this article series ended, we finished using Database Workload Capture to collect two different workloads from an Oracle 11.2.0.3 database — one OLTP workload, and one DSS workload — and saved the resulting shadow capture files for eventual transference to a new platform for Database Workload Replay testing and evaluation.

Have you ever faced a plan performance regression in your Oracle database after a version upgrade? One of your core's production SQLs suddenly changed its execution plan slowing down your application? SQL Plan Management (SPM) 12c is the ultimate plan stability solution to prevent plan performance regressions by giving you the flexibility to tell the CBO…

The challenge with every new release of the Oracle Database is how does one get there? In this presentation we will discuss the various methods to take your database to 12c along with the pros and cons of each. The challenge is to look at your applications, how they use the database and how much…

With the release of OBIEE 12c, Oracle's flagship Business Intelligence product continues to evolve and improve.

Learn about latest ways to upgrade, migrate, and consolidate databases in Oracle Database 12c. This hands on lab includes; upgrading using the new command-line parallel upgrade script, plugging that database into container database, and migrating a database to a pluggable database using the full transportable export/import feature. #IOUGeniusDBReady

Oracle has introduced database deployment technologies in Oracle 12c to support managed consolidated private database clouds and DBaaS deployments. This session is targeted at architects and administrators tasked to design and deploy such systems. It will review the availability and management issues such as ensuring critical services start first and go down last, workloads stay…

Original Broadcast: Wednesday, January 21, 2015 12:00 p.m. - 1:00 p.m. The goal in every Oracle Manager 12c rollout is to take it from zero to manageability in the shortest time possible. This presentation will show you how to accomplish this feat. Speakers will demonstrate how to properly architect and deploy Oracle Enterprise Manager 12c…

GoldenGate is widely used technology to replicate mission critical OLTP databases to separate database for consolidated and real time operational reporting. This session will provide overview as well as many specific performance tuning techniques used at U.S. Celluar to replicate 3-5 TB trail files generated daily. The techniques include GoldenGate 12c infrastructure design, source and…

Oracle RAC Policy-Managed Database (PMD) is a powerful but so far rarely used feature introduced in Oracle Database 11g Release 2 to automate the instance administration in a dynamic, multi-node cluster. The aim of this presentation is to review how PMD works, how to implement and administer it successfully, and how to benefit from this…

This presentation will look at 12c to 21c new features that should be investigated for use which include Multitenant, IN-Memory and Oracle 19c Automatic Indexing and many more. I will discuss the 12c to 21c Journey for these new features with examples and sample code. Attendees can expect brief introduction of all the new features with deep dive into Multitenant, IN-Memory and Automatic Indexing